brian nicol , 32 from glasgow , dived into a pool but failed to resurface .
frantic friends dragged him out of the water but he could not be revived .
group were partying around pool after night out in marbella , says source .
early investigations show death was a ` tragic accident ' according to police .